[dbo].[vGenTablesUnion]

SQLServer > iMIS1521GA > Views > dbo.vGenTablesUnion

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	3:38:14 PM Friday, January 07, 2011
Last Modified	1:48:44 PM Thursday, September 22, 2011

Columns

Name
TABLE_NAME
CODE
DESCRIPTION

SQL Script

/****** Object:  View dbo.vGenTablesUnion    Script Date: 7/3/2003 4:57:56 PM ******/
CREATE VIEW vGenTablesUnion AS
SELECT    TABLE_NAME, CODE, DESCRIPTION
FROM    Gen_Tables
WHERE    SUBSTITUTE <= ' '
UNION
SELECT    TABLE_NAME, SUBSTITUTE, DESCRIPTION
FROM    Gen_Tables
WHERE    SUBSTITUTE > ' '

GO

Uses

[dbo].[Gen_Tables]
dbo